<?xml version="1.0" encoding="UTF-8"?>
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<%@ page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>

<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>

<html xmlns="http://www.w3.org/1999/xhtml" dir="rtl">
    <head>
        <meta http-equiv="content-type" content="text/html; charset=UTF-8" />
        <title>Admin Page</title>
    </head>

    <body>
        <h1>header</h1>

        <% 
		ResultSet resultset = (ResultSet)request.getAttribute("resultset");
        %>

        <table border="1">
            <tr>
                <th>id</th>
                <th>name</th>
            </tr>
            <% if (resultset != null) { %>
            <% while(resultset.next()){ %>
            <tr>
                <td> <%= resultset.getString("id") %></td>
                <td> <%= resultset.getString("name") %></td>
            </tr>
            <% }
            resultset.close();
            }
            %>
        </table>
        
    </body>
</html>